package com.bsoft.gol.hcs.specialist.dao;

/**
 * @Author:FangZhiyi
 * @Description
 * @Data Created in 2020/7/15 9:49
 * @Moddified By:
 */

import ctd.persistence.annotation.DAOMethod;
import ctd.persistence.annotation.DAOParam;
import ctd.persistence.support.hibernate.HibernateSupportDelegateDAO;
import com.bsoft.gol.hcs.specialist.entity.FollowUpRouteDetailContent;

import java.util.List;

public abstract class FollowUpRouteDetailContentDAO extends HibernateSupportDelegateDAO<FollowUpRouteDetailContent> {

	@DAOMethod(sql = " from  FollowUpRouteDetailContent where organization_id=:orgId and route_id =:routeId and" +
			" route_detail_id=:routeDetailId")
	public abstract List<FollowUpRouteDetailContent> queryFollowUpList(@DAOParam("orgId") String organizationId,
																	   @DAOParam("routeId") Long routeId, @DAOParam(
																	   		"routeDetailId") long routeDetailId);

	@DAOMethod(sql = "DELETE from FollowUpRouteDetailContent where route_detail_id =:routeDetailId ")
	public abstract void deleteContentByRouteDetailId(@DAOParam("routeDetailId") Long routeDetailId);

	@DAOMethod(sql = " from  FollowUpRouteDetailContent where route_detail_id =:routeDetailId ")
	public abstract List<FollowUpRouteDetailContent> queryByRouteDetailId(@DAOParam("routeDetailId") Long routeDetailId);
}
